package com.byxy.ssm.demo.dao;

import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import com.byxy.ssm.demo.entity.User;

public interface UserDao {

	@Results({ 
		@Result(column = "user_id", property = "userId", id = true),
		@Result(column = "user_name", property = "userName"), 
		@Result(column = "user_nick", property = "userNick"),
		@Result(column = "user_password", property = "userPassword"),
		@Result(column = "user_status", property = "userStatus"),
		@Result(column = "user_type", property = "userType"), 
	})
	@Select("select * from user where user_id = #{id}")
	User getById(Integer id);
}
